WITH ALGORITHM = AES_256

go

复制代码 代码如下:

ENCRYPTION BY PASSWORD = 'password' ;
as nvarchar (200)),
WITH ALGORITHM = RSA_2048
ALTER ASYMMETRIC KEY TestAsymmetric WITH PRIVATE KEY (DECRYPTION BY PASSWORD = 'password1')
CREATE CERTIFICATE CertTest
OPEN SYMMETRIC KEY 命令关于 对称密钥加密使用证书解密
FROM sys .objects
CREATE SYMMETRIC KEY TestSymmetric
ENCRYPTBYASYMKEY(ASYMKEY_ID ('TestAsymmetric'), name) ,
ENCRYPTBYCERT ( Cert_ID('CertTest' ),name),
SELECT
CREATE ASYMMETRIC KEY TestAsymmetric
GO
go
CAST(decryptByKey (EncryptByKey (KEY_GUID ('TestSymmetric'), name))
CAST(deCRYPTBYASYMKEY (ASYMKEY_ID( 'TestAsymmetric'),ENCRYPTBYASYMKEY (ASYMKEY_ID( 'TestAsymmetric'),name ) )
--创建对称密钥
GO
ENCRYPTION BY PASSWORD = 'password1' ;
--DROP ASYMMETRIC KEY TestAsymmetric
as nvarchar(200 )),
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'
as nvarchar (200))
with SUBJECT = 'Test Certificate'
CAST(deCRYPTBYCERT (Cert_ID ('CertTest'), ENCRYPTBYCERT (Cert_ID( 'CertTest'),name ))
DECRYPTION BY PASSWORD = 'password' ;

GO
EncryptByKey ( KEY_GUID('TestSymmetric' ),name),
OPEN SYMMETRIC KEY TestSymmetric

--创建非对称密钥